Kolumna AccountDataID tabeli AccountData

Definicja kolumny AccountDataID tabeli AccountData

Name

AccountDataID

Code

AccountDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Acc_AccountDataID tabeli AccountData

Definicja kolumny Acc_AccountDataID tabeli AccountData

Name

Acc_AccountDataID

Code

Acc_AccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli AccountData

Definicja kolumny EventID tabeli AccountData

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna ContractServID tabeli AccountData

Definicja kolumny ContractServID tabeli AccountData

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractServID tabeli AccountData

Definicja kolumny Con_ContractServID tabeli AccountData

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InstanceTypeID tabeli AccountData

Definicja kolumny InstanceTypeID tabeli AccountData

Name

InstanceTypeID

Code

InstanceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DialysisID tabeli AccountData

Definicja kolumny DialysisID tabeli AccountData

Name

DialysisID

Code

DialysisID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountDataPOZID tabeli AccountData

Definicja kolumny AccountDataPOZID tabeli AccountData

Name

AccountDataPOZID

Code

AccountDataPOZID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ChemotherapyID tabeli AccountData

Definicja kolumny ChemotherapyID tabeli AccountData

Name

ChemotherapyID

Code

ChemotherapyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsuranceID tabeli AccountData

Definicja kolumny InsuranceID tabeli AccountData

Name

InsuranceID

Code

InsuranceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceID tabeli AccountData

Definicja kolumny InvoiceID tabeli AccountData

Name

InvoiceID

Code

InvoiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli AccountData

Definicja kolumny ContractID tabeli AccountData

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgreementType tabeli AccountData

Definicja kolumny AgreementType tabeli AccountData

Name

AgreementType

Code

AgreementType

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Code tabeli AccountData

Definicja kolumny Code tabeli AccountData

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CodeType tabeli AccountData

Definicja kolumny CodeType tabeli AccountData

Name

CodeType

Code

CodeType

Data Type

CHAR(1)

Mandatory

No

Comment

 


Kolumna ContractNo tabeli AccountData

Definicja kolumny ContractNo tabeli AccountData

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Cost tabeli AccountData

Definicja kolumny Cost tabeli AccountData

Name

Cost

Code

Cost

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna InstallationID tabeli AccountData

Definicja kolumny InstallationID tabeli AccountData

Name

InstallationID

Code

InstallationID

Data Type

VARCHAR2(38)

Mandatory

No

Comment

 


Kolumna isEmergency tabeli AccountData

Definicja kolumny isEmergency tabeli AccountData

Name

isEmergency

Code

isEmergency

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Month tabeli AccountData

Definicja kolumny Month tabeli AccountData

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PointsPerUnit tabeli AccountData

Definicja kolumny PointsPerUnit tabeli AccountData

Name

PointsPerUnit

Code

PointsPerUnit

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Price tabeli AccountData

Definicja kolumny Price tabeli AccountData

Name

Price

Code

Price

Data Type

NUMBER(22,6)

Mandatory

No

Comment

 


Kolumna Selector tabeli AccountData

Definicja kolumny Selector tabeli AccountData

Name

Selector

Code

Selector

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SpecificAccounting tabeli AccountData

Definicja kolumny SpecificAccounting tabeli AccountData

Name

SpecificAccounting

Code

SpecificAccounting

Data Type

VARCHAR2(3)

Mandatory

No

Comment

 


Kolumna StartDT tabeli AccountData

Definicja kolumny StartDT tabeli AccountData

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli AccountData

Definicja kolumny StopDT tabeli AccountData

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Surcharge tabeli AccountData

Definicja kolumny Surcharge tabeli AccountData

Name

Surcharge

Code

Surcharge

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna UnitPrice tabeli AccountData

Definicja kolumny UnitPrice tabeli AccountData

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Year tabeli AccountData

Definicja kolumny Year tabeli AccountData

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExtProductID tabeli AccountData

Definicja kolumny ExtProductID tabeli AccountData

Name

ExtProductID

Code

ExtProductID

Data Type

VARCHAR2(80)

Mandatory

No

Comment

 


Kolumna OCStatus tabeli AccountData

Definicja kolumny OCStatus tabeli AccountData

Name

OCStatus

Code

OCStatus

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna OCdocumentNo tabeli AccountData

Definicja kolumny OCdocumentNo tabeli AccountData

Name

OCdocumentNo

Code

OCdocumentNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna OperationDocumentNo tabeli AccountData

Definicja kolumny OperationDocumentNo tabeli AccountData

Name

OperationDocumentNo

Code

OperationDocumentNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna PerfUnitsCount tabeli AccountData

Definicja kolumny PerfUnitsCount tabeli AccountData

Name

PerfUnitsCount

Code

PerfUnitsCount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli AccountData

Definicja kolumny UnitsCount tabeli AccountData

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

 


Kolumna AccountingMonth tabeli AccountData

Definicja kolumny AccountingMonth tabeli AccountData

Name

AccountingMonth

Code

AccountingMonth

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountingYear tabeli AccountData

Definicja kolumny AccountingYear tabeli AccountData

Name

AccountingYear

Code

AccountingYear

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgreementNo tabeli AccountData

Definicja kolumny AgreementNo tabeli AccountData

Name

AgreementNo

Code

AgreementNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna CurrentAccountDataStatusID tabeli AccountData

Definicja kolumny CurrentAccountDataStatusID tabeli AccountData

Name

CurrentAccountDataStatusID

Code

CurrentAccountDataStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GrouperVersionNo tabeli AccountData

Definicja kolumny GrouperVersionNo tabeli AccountData

Name

GrouperVersionNo

Code

GrouperVersionNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna Tariff tabeli AccountData

Definicja kolumny Tariff tabeli AccountData

Name

Tariff

Code

Tariff

Data Type

NUMBER(16,4)

Mandatory

No

Comment

 


Kolumna ToVeryfication tabeli AccountData

Definicja kolumny ToVeryfication tabeli AccountData

Name

ToVeryfication

Code

ToVeryfication

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna MzArticleCode tabeli AccountData

Definicja kolumny MzArticleCode tabeli AccountData

Name

MzArticleCode

Code

MzArticleCode

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna ArticleIssuePeriod tabeli AccountData

Definicja kolumny ArticleIssuePeriod tabeli AccountData

Name

ArticleIssuePeriod

Code

ArticleIssuePeriod

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LimitIssuePeriodStartDate tabeli AccountData

Definicja kolumny LimitIssuePeriodStartDate tabeli AccountData

Name

LimitIssuePeriodStartDate

Code

LimitIssuePeriodStartDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SupplyProductID tabeli AccountData

Definicja kolumny SupplyProductID tabeli AccountData

Name

SupplyProductID

Code

SupplyProductID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AlternativeContractNo tabeli AccountData

Definicja kolumny AlternativeContractNo tabeli AccountData

Name

AlternativeContractNo

Code

AlternativeContractNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna NfzLastSwzMessageNo tabeli AccountData

Definicja kolumny NfzLastSwzMessageNo tabeli AccountData

Name

NfzLastSwzMessageNo

Code

NfzLastSwzMessageNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ParentAccountDataID tabeli AccountData

Definicja kolumny ParentAccountDataID tabeli AccountData

Name

ParentAccountDataID

Code

ParentAccountDataID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BarthelScale tabeli AccountData

Definicja kolumny BarthelScale tabeli AccountData

Name

BarthelScale

Code

BarthelScale

Data Type

NUMBER(3)

Mandatory

No

Comment

Skala Barthel dla swiadczen pielegnacyjnych i opiekunczych


Kolumna GlasgowScale tabeli AccountData

Definicja kolumny GlasgowScale tabeli AccountData

Name

GlasgowScale

Code

GlasgowScale

Data Type

NUMBER(5)

Mandatory

No

Comment

Skala Glasgow dla swiadczen pielegnacyjnych i opiekunczych


Kolumna FinancedAccountingUnits tabeli AccountData

Definicja kolumny FinancedAccountingUnits tabeli AccountData

Name

FinancedAccountingUnits

Code

FinancedAccountingUnits

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Liczba jednostek rozliczeniowych zaakceptowana przez platnika do fakturowania


Kolumna StatisticAccountingUnits tabeli AccountData

Definicja kolumny StatisticAccountingUnits tabeli AccountData

Name

StatisticAccountingUnits

Code

StatisticAccountingUnits

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Liczba jednostek rozliczeniowych przekazana w komunikacie SWIAD wynikajaca z umowy (wynikajaca z wagi,taryfy i krotnosci)


Kolumna TotalStatisticDays tabeli AccountData

Definicja kolumny TotalStatisticDays tabeli AccountData

Name

TotalStatisticDays

Code

TotalStatisticDays

Data Type

NUMBER(10)

Mandatory

No

Comment

Calkowita liczba dni w których bylo udzielane swiadczenie finansowane dana pozycja rozliczeniowa (okreslona w atrybucie id-poz-rozl)


Kolumna FinancedDays tabeli AccountData

Definicja kolumny FinancedDays tabeli AccountData

Name

FinancedDays

Code

FinancedDays

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczba dni finansowanych dana pozycja rozliczeniowa (okreslona w atrybucie id-poz-rozl)


Kolumna SettlementAnnexNumber tabeli AccountData

Definicja kolumny SettlementAnnexNumber tabeli AccountData

Name

SettlementAnnexNumber

Code

SettlementAnnexNumber

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Nr aneksu ugodowego.


Kolumna OAiITCharacter tabeli AccountData

Definicja kolumny OAiITCharacter tabeli AccountData

Name

OAiITCharacter

Code

OAiITCharacter

Data Type

VARCHAR2(15)

Mandatory

No

Comment

Informacje o rozliczeniach osobodnia dla swiadczen realizowanych w OAiIT


Kolumna AdmCodeId tabeli AccountData

Definicja kolumny AdmCodeId tabeli AccountData

Name

AdmCodeId

Code

AdmCodeId

Data Type

NUMBER(12,0)

Mandatory

No

Comment

ID kodu terytorialnego


Kolumna Student tabeli AccountData

Definicja kolumny Student tabeli AccountData

Name

Student

Code

Student

Data Type

NUMBER(3)

Mandatory

No

Comment

czy pacjent jest studentem


Kolumna CataractAcutance tabeli AccountData

Definicja kolumny CataractAcutance tabeli AccountData

Name

CataractAcutance

Code

CataractAcutance

Data Type

NUMBER(4,2)

Mandatory

No

Comment

ostrosc wzroku wg skali Snellena


Kolumna CataractCrack tabeli AccountData

Definicja kolumny CataractCrack tabeli AccountData

Name

CataractCrack

Code

CataractCrack

Data Type

NUMBER(3)

Mandatory

No

Comment

pekniecie torebki tylnej


Kolumna CataractInflammation tabeli AccountData

Definicja kolumny CataractInflammation tabeli AccountData

Name

CataractInflammation

Code

CataractInflammation

Data Type

NUMBER(3)

Mandatory

No

Comment

zapalenie wnetrza galki ocznej


Kolumna LeftEyeCataractalConditions tabeli AccountData

Definicja kolumny LeftEyeCataractalConditions tabeli AccountData

Name

LeftEyeCataractalConditions

Code

LeftEyeCataractalConditions

Data Type

VARCHAR2(20)

Mandatory

No

Comment

warunki finansowania swiad. usuniecia zacmy (oko lewe)


Kolumna LeftEyeCataractalAcutance tabeli AccountData

Definicja kolumny LeftEyeCataractalAcutance tabeli AccountData

Name

LeftEyeCataractalAcutance

Code

LeftEyeCataractalAcutance

Data Type

NUMBER(4,2)

Mandatory

No

Comment

ostrosc wzroku wg skali Snellena


Kolumna LeftEyeCataractalInflammation tabeli AccountData

Definicja kolumny LeftEyeCataractalInflammation tabeli AccountData

Name

LeftEyeCataractalInflammation

Code

LeftEyeCataractalInflammation

Data Type

NUMBER(3)

Mandatory

No

Comment

zapalenie wnetrza galki ocznej


Kolumna LeftEyeCataractalCrack tabeli AccountData

Definicja kolumny LeftEyeCataractalCrack tabeli AccountData

Name

LeftEyeCataractalCrack

Code

LeftEyeCataractalCrack

Data Type

NUMBER(3)

Mandatory

No

Comment

pekniecie torebki tylnej


Kolumna RightEyeCataractalConditions tabeli AccountData

Definicja kolumny RightEyeCataractalConditions tabeli AccountData

Name

RightEyeCataractalConditions

Code

RightEyeCataractalConditions

Data Type

VARCHAR2(20)

Mandatory

No

Comment

warunki finansowania swiad. usuniecia zacmy (oko lewe)


Kolumna RightEyeCataractalAcutance tabeli AccountData

Definicja kolumny RightEyeCataractalAcutance tabeli AccountData

Name

RightEyeCataractalAcutance

Code

RightEyeCataractalAcutance

Data Type

NUMBER(4,2)

Mandatory

No

Comment

ostrosc wzroku wg skali Snellena


Kolumna RightEyeCataractalInflammation tabeli AccountData

Definicja kolumny RightEyeCataractalInflammation tabeli AccountData

Name

RightEyeCataractalInflammation

Code

RightEyeCataractalInflammation

Data Type

NUMBER(3)

Mandatory

No

Comment

zapalenie wnetrza galki ocznej


Kolumna RightEyeCataractalCrack tabeli AccountData

Definicja kolumny RightEyeCataractalCrack tabeli AccountData

Name

RightEyeCataractalCrack

Code

RightEyeCataractalCrack

Data Type

NUMBER(3)

Mandatory

No

Comment

pekniecie torebki tylnej


Kolumna PregnancyWeek tabeli AccountData

Definicja kolumny PregnancyWeek tabeli AccountData

Name

PregnancyWeek

Code

PregnancyWeek

Data Type

NUMBER(3)

Mandatory

No

Comment

Tydzien ciazy


Kolumna IsRateModifierApplied tabeli AccountData

Definicja kolumny IsRateModifierApplied tabeli AccountData

Name

IsRateModifierApplied

Code

IsRateModifierApplied

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy zastosowano modyfikator taryfy


Lista kluczy tabeli AccountData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AccountData

Definicja klucza Identifier_1 tabeli AccountData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment